<report xmlns="http://developer.cognos.com/schemas/report/12.0/" expressionLocale="en-us" useStyleVersion="10"><!--RSU-SPC-0093 The report specification was upgraded from "http://developer.cognos.com/schemas/report/11.0/" to "http://developer.cognos.com/schemas/report/12.0/" at 2016-3-31. 9:10:51-->
				<modelPath>/content/folder[@name='Packages']/package[@name='Inventory']/model[@name='model']</modelPath>
				<drillBehavior modelBasedDrillThru="true"/>
				
				<layouts>
					<layout>
						<reportPages>
							<page name="Page1"><style><defaultStyles><defaultStyle refStyle="pg"/></defaultStyles></style>
								<pageBody><style><defaultStyles><defaultStyle refStyle="pb"/></defaultStyles></style>
									<contents>
										
									<HTMLItem>
			<dataSource>
				<staticValue>&lt;style&gt; #headerBack { display: none; } .mainHeader1 { display: none; } .mainViewerHeader3 { display: none; } &lt;/style&gt;</staticValue>
			</dataSource>
		</HTMLItem><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Powered by OnCommand Insight</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:bold;color:white"/></style></textItem></contents><style><CSS value="height:24px;padding-left:24px;background-color:#6198C5"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Capacity Recovery or Cost Reduction - Executive Summary</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:24px;color:#333333"/></style></textItem></contents><style><CSS value="height:36px;background-color:#FBFBFB;padding-left:24px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="border:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="background-color:#F7F7F7"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Business Unit Orphaned Capacity</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(by Configuration)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart depth="9" maxHotspots="10000" name="Combination Chart1" refQuery="Orphaned by BU">
														<v2_combinationTypeTooltips/>
														<v2_commonAxis>
															<v2_ordinalAxis autoTruncation="false" truncationText="..." manualTruncationMaxChars="15">
																
																
																<v2_axisLabels>
																	<style>
																		<defaultStyles>
																			<defaultStyle refStyle="al"/>
																		</defaultStyles>
																	<CSS value="color:#454545"/></style>
																</v2_axisLabels>
															</v2_ordinalAxis>
														<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Business Unit"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
														<v2_topLeftAxis>
															<v2_combinationChartTypes>
																<v2_bar barShape="box" borderColor="white">
																	<v2_solidPalette>
																		
																	<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
																	<!-- v2_solidPaletteRef ref=&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;gDefaultSolid&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;/ -->
																<v2_chartDataLabels displayDataLocation="outsideAtTop" labelCollisionMode="fine_stagger" labelValueType="absolute" leaderLines="hide"/><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Orphaned (TB)"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
															</v2_combinationChartTypes>
															<v2_axis>
																
																
																<v2_axisRange scale="log">
																	<v2_automaticRange sameRangeAllInstances="true" includeZeroForAutoScale="true"/>
																</v2_axisRange>
																<v2_axisLabels>
																	<style>
																		<defaultStyles>
																			<defaultStyle refStyle="al"/>
																		</defaultStyles>
																	<dataFormat><numberFormat pattern="###,###' TB'"/></dataFormat><CSS value="color:#454545"/></style>
																</v2_axisLabels>
																<v2_majorGridlines lineColor="#CCCCCC" lineWeight="0"/>
															</v2_axis>
														</v2_topLeftAxis>
														<style>
															<defaultStyles>
																<defaultStyle refStyle="ch"/>
															</defaultStyles>
															<CSS value="width:410px;height:200px;color:#454545"/></style>
														<noDataHandler>
															<contents>
																<block>
																	<contents>
																		<textItem>
																			<dataSource>
																				<staticValue>No Data Available</staticValue>
																			</dataSource>
																			<style>
																				<CSS value="padding:10px 18px;"/>
																			</style>
																		</textItem>
																	</contents>
																</block>
															</contents>
														</noDataHandler>
														<XMLAttributes><XMLAttribute name="titlesExpanded" output="no" value="true"/></XMLAttributes>
														</v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Vendor Orphaned Capacity</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(by Configuration)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart depth="9" maxHotspots="10000" name="Combination Chart2" refQuery="Orphaned by Vendor">
	<v2_combinationTypeTooltips/>
	<v2_commonAxis>
		<v2_ordinalAxis>
			
			
			<v2_axisLabels>
				<style>
					<defaultStyles>
						<defaultStyle refStyle="al"/>
					</defaultStyles>
				<CSS value="color:#454545"/></style>
			</v2_axisLabels>
		</v2_ordinalAxis>
	<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Manufacturer"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
	<v2_topLeftAxis>
		<v2_combinationChartTypes>
			<v2_bar barShape="box" borderColor="white">
				<v2_solidPalette>
					
				<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
				<!-- v2_solidPaletteRef ref=&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;gDefaultSolid&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;/ -->
			<v2_chartDataLabels displayDataLocation="outsideAtTop" labelCollisionMode="fine_stagger" labelValueType="absolute" leaderLines="hide"/><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Orphaned (TB)"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
		</v2_combinationChartTypes>
		<v2_axis>
			
			
			<v2_axisRange scale="log">
				<v2_automaticRange sameRangeAllInstances="true" includeZeroForAutoScale="true"/>
			</v2_axisRange>
			<v2_axisLabels>
				<style>
					<defaultStyles>
						<defaultStyle refStyle="al"/>
					</defaultStyles>
				<dataFormat><numberFormat pattern="###,###' TB'"/></dataFormat><CSS value="color:#454545"/></style>
			</v2_axisLabels>
			<v2_majorGridlines lineColor="#CCCCCC" lineWeight="0"/>
		</v2_axis>
	</v2_topLeftAxis>
	<style>
		<defaultStyles>
			<defaultStyle refStyle="ch"/>
		</defaultStyles>
		<CSS value="width:410px;height:200px;color:#454545"/></style>
	<noDataHandler>
		<contents>
			<block>
				<contents>
					<textItem>
						<dataSource>
							<staticValue>No Data Available</staticValue>
						</dataSource>
						<style>
							<CSS value="padding:10px 18px;"/>
						</style>
					</textItem>
				</contents>
			</block>
		</contents>
	</noDataHandler>
	<XMLAttributes><XMLAttribute name="titlesExpanded" output="no" value="true"/></XMLAttributes>
	</v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top;padding-left:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Service Level Orphaned</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(by Configuration)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart depth="9" maxHotspots="10000" name="Combination Chart3" refQuery="Orphaned by Service Level or Tier">
	<v2_combinationTypeTooltips/>
	<v2_commonAxis>
		<v2_ordinalAxis>
			
			
			<v2_axisLabels>
				<style>
					<defaultStyles>
						<defaultStyle refStyle="al"/>
					</defaultStyles>
				<CSS value="color:#454545"/></style>
			</v2_axisLabels>
		</v2_ordinalAxis>
	<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Service Level"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
	<v2_topLeftAxis>
		<v2_combinationChartTypes>
			<v2_bar barShape="box" borderColor="white">
				<v2_solidPalette>
					
				<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
				<!-- v2_solidPaletteRef ref=&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;gDefaultSolid&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;/ -->
			<v2_chartDataLabels displayDataLocation="outsideAtTop" labelCollisionMode="fine_stagger" labelValueType="absolute" leaderLines="hide"/><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Orphaned (TB)"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
		</v2_combinationChartTypes>
		<v2_axis>
			
			
			<v2_axisRange>
				<v2_automaticRange/>
			</v2_axisRange>
			<v2_axisLabels>
				<style>
					<defaultStyles>
						<defaultStyle refStyle="al"/>
					</defaultStyles>
				<dataFormat><numberFormat pattern="###,###' TB'"/></dataFormat><CSS value="color:#454545"/></style>
			</v2_axisLabels>
			<v2_majorGridlines lineColor="#CCCCCC" lineWeight="0"/>
		</v2_axis>
	</v2_topLeftAxis>
	<style>
		<defaultStyles>
			<defaultStyle refStyle="ch"/>
		</defaultStyles>
		<CSS value="width:410px;height:200px;color:#454545"/></style>
	<noDataHandler>
		<contents>
			<block>
				<contents>
					<textItem>
						<dataSource>
							<staticValue>No Data Available</staticValue>
						</dataSource>
						<style>
							<CSS value="padding:10px 18px;"/>
						</style>
					</textItem>
				</contents>
			</block>
		</contents>
	</noDataHandler>
	<XMLAttributes><XMLAttribute name="titlesExpanded" output="no" value="true"/></XMLAttributes>
	</v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top;padding-left:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="height:10px;background-color:#F7F7F7;padding-right:10px;padding-left:10px;padding-top:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Business Unit Orphaned</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(by Performance)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart depth="9" maxHotspots="10000" name="Combination Chart4" refQuery="Storage at Rest for BU">
														<v2_combinationTypeTooltips/>
														<v2_commonAxis>
															<v2_ordinalAxis autoTruncation="false" truncationText="..." manualTruncationMaxChars="12">
																
																
																<v2_axisLabels>
																	<style>
																		<defaultStyles>
																			<defaultStyle refStyle="al"/>
																		</defaultStyles>
																	<CSS value="color:#454545"/></style>
																</v2_axisLabels>
															</v2_ordinalAxis>
														<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="BusinessUnit"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
														<v2_topLeftAxis>
															<v2_combinationChartTypes>
																<v2_bar barShape="box" borderColor="white">
																	<v2_solidPalette>
																		
																	<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
																	<!-- v2_solidPaletteRef ref=&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;gDefaultSolid&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;/ -->
																<v2_chartDataLabels displayDataLocation="outsideAtTop" labelCollisionMode="fine_stagger" labelValueType="absolute" leaderLines="hide"/><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="CapacityTB"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><numberFormat decimalSize="2"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
															</v2_combinationChartTypes>
															<v2_axis>
																
																
																<v2_axisRange scale="log">
																	<v2_automaticRange sameRangeAllInstances="true" includeZeroForAutoScale="true"/>
																</v2_axisRange>
																<v2_axisLabels>
																	<style>
																		<defaultStyles>
																			<defaultStyle refStyle="al"/>
																		</defaultStyles>
																	<dataFormat><numberFormat pattern="###,###' TB'"/></dataFormat><CSS value="color:#454545"/></style>
																</v2_axisLabels>
																<v2_majorGridlines lineColor="#CCCCCC" lineWeight="0"/>
															</v2_axis>
														</v2_topLeftAxis>
														<style>
															<defaultStyles>
																<defaultStyle refStyle="ch"/>
															</defaultStyles>
															<CSS value="width:410px;height:200px;color:#454545"/></style>
														<noDataHandler>
															<contents>
																<block>
																	<contents>
																		<textItem>
																			<dataSource>
																				<staticValue>No Data Available</staticValue>
																			</dataSource>
																			<style>
																				<CSS value="padding:10px 18px;"/>
																			</style>
																		</textItem>
																	</contents>
																</block>
															</contents>
														</noDataHandler>
														<XMLAttributes><XMLAttribute name="titlesExpanded" output="no" value="true"/></XMLAttributes>
														</v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Vendor Orphaned Capacity</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(by Performance)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart depth="9" maxHotspots="10000" name="Combination Chart5" refQuery="Storage at Rest - Tier and Vendor">
	<v2_combinationTypeTooltips/>
	<v2_commonAxis>
		<v2_ordinalAxis>
			
			
			<v2_axisLabels>
				<style>
					<defaultStyles>
						<defaultStyle refStyle="al"/>
					</defaultStyles>
				<CSS value="color:#454545"/></style>
			</v2_axisLabels>
		</v2_ordinalAxis>
	<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Vendor"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
	<v2_topLeftAxis>
		<v2_combinationChartTypes>
			<v2_bar barShape="box" borderColor="white">
				<v2_solidPalette>
					
				<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
				<!-- v2_solidPaletteRef ref=&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;gDefaultSolid&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;/ -->
			<v2_chartDataLabels displayDataLocation="outsideAtTop" labelCollisionMode="fine_stagger" labelValueType="absolute" leaderLines="hide"/><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Capacity TB"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
		</v2_combinationChartTypes>
		<v2_axis>
			
			
			<v2_axisRange>
				<v2_automaticRange/>
			</v2_axisRange>
			<v2_axisLabels>
				<style>
					<defaultStyles>
						<defaultStyle refStyle="al"/>
					</defaultStyles>
				<dataFormat><numberFormat pattern="###,###' TB'"/></dataFormat><CSS value="color:#454545"/></style>
			</v2_axisLabels>
			<v2_majorGridlines lineColor="#CCCCCC" lineWeight="0"/>
		</v2_axis>
	</v2_topLeftAxis>
	<style>
		<defaultStyles>
			<defaultStyle refStyle="ch"/>
		</defaultStyles>
		<CSS value="width:410px;height:200px;color:#454545"/></style>
	<noDataHandler>
		<contents>
			<block>
				<contents>
					<textItem>
						<dataSource>
							<staticValue>No Data Available</staticValue>
						</dataSource>
						<style>
							<CSS value="padding:10px 18px;"/>
						</style>
					</textItem>
				</contents>
			</block>
		</contents>
	</noDataHandler>
	<XMLAttributes><XMLAttribute name="titlesExpanded" output="no" value="true"/></XMLAttributes>
	</v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top;padding-left:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Service Level Orphaned</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(by Performance)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart depth="9" maxHotspots="10000" name="Combination Chart6" refQuery="Storage at Rest - Tier and Vendor">
	<v2_combinationTypeTooltips/>
	<v2_commonAxis>
		<v2_ordinalAxis>
			
			
			<v2_axisLabels>
				<style>
					<defaultStyles>
						<defaultStyle refStyle="al"/>
					</defaultStyles>
				<CSS value="color:#454545"/></style>
			</v2_axisLabels>
		</v2_ordinalAxis>
	<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Tier"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
	<v2_topLeftAxis>
		<v2_combinationChartTypes>
			<v2_bar barShape="box" borderColor="silver">
				<v2_solidPalette>
					
				<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
				<!-- v2_solidPaletteRef ref=&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;gDefaultSolid&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;/ -->
			<v2_chartDataLabels displayDataLocation="outsideAtTop" labelCollisionMode="fine_stagger" labelValueType="absolute" leaderLines="hide"/><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Capacity TB"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
		</v2_combinationChartTypes>
		<v2_axis>
			
			
			<v2_axisRange>
				<v2_automaticRange/>
			</v2_axisRange>
			<v2_axisLabels>
				<style>
					<defaultStyles>
						<defaultStyle refStyle="al"/>
					</defaultStyles>
				<dataFormat><numberFormat pattern="###,###' TB'"/></dataFormat><CSS value="color:#454545"/></style>
			</v2_axisLabels>
			<v2_majorGridlines lineColor="#CCCCCC" lineWeight="0"/>
		</v2_axis>
	</v2_topLeftAxis>
	<style>
		<defaultStyles>
			<defaultStyle refStyle="ch"/>
		</defaultStyles>
		<CSS value="width:410px;height:200px;color:#454545"/></style>
	<noDataHandler>
		<contents>
			<block>
				<contents>
					<textItem>
						<dataSource>
							<staticValue>No Data Available</staticValue>
						</dataSource>
						<style>
							<CSS value="padding:10px 18px;"/>
						</style>
					</textItem>
				</contents>
			</block>
		</contents>
	</noDataHandler>
	<XMLAttributes><XMLAttribute name="titlesExpanded" output="no" value="true"/></XMLAttributes>
	</v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top;padding-left:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding:5px 10px 5px 10px;background-color:#F7F7F7"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Orphaned %</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(by Business Unit)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_pieChart maxHotspots="10000" name="Pie Chart3" refQuery="Orphaned by BU" sliceStartAngle="90">
	<v2_pieTooltips/>
	<style>
		<defaultStyles>
			<defaultStyle refStyle="ch"/>
		</defaultStyles>
		<CSS value="width:300px;height:250px;color:#454545"/></style>
	<noDataHandler>
		<contents>
			<block>
				<contents>
					<textItem>
						<dataSource>
							<staticValue>No Data Available</staticValue>
						</dataSource>
						<style>
							<CSS value="padding:10px 18px;"/>
						</style>
					</textItem>
				</contents>
			</block>
		</contents>
	</noDataHandler>
	<v2_pieSlices borders="show" borderColor="white">
		<v2_solidPalette>
			<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
		<!-- v2_solidPaletteRef ref=&amp;quot;gDefaultSolid&amp;quot;/ -->
		<v2_pieDataLabels pieLabelLeaders="show" pieLabelStyle="radial" pieLabels="show" pieValues="percentage"/><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Business Unit"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_pieSlices>
	<v2_defaultChartMeasure refDataItem="Orphaned (TB)"/></v2_pieChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Orphaned %</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(by Tier/Service Level)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_pieChart maxHotspots="10000" name="Pie Chart1" refQuery="Orphaned by Service Level or Tier" sliceStartAngle="90">
																				<v2_pieTooltips/>
																				<style>
																					<defaultStyles>
																						<defaultStyle refStyle="ch"/>
																					</defaultStyles>
																					<CSS value="width:300px;height:250px;color:#454545"/></style>
																				<noDataHandler>
																					<contents>
																						<block>
																							<contents>
																								<textItem>
																									<dataSource>
																										<staticValue>No Data Available</staticValue>
																									</dataSource>
																									<style>
																										<CSS value="padding:10px 18px;"/>
																									</style>
																								</textItem>
																							</contents>
																						</block>
																					</contents>
																				</noDataHandler>
																				<v2_pieSlices borderColor="white" borders="show">
																					<v2_solidPalette>
																						<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
																					<!-- v2_solidPaletteRef ref=&amp;quot;gDefaultSolid&amp;quot;/ -->
																					<v2_pieDataLabels pieLabelLeaders="show" pieLabelStyle="radial" pieLabels="show" pieValues="percentage"/><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Service Level"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_pieSlices>
																				<v2_defaultChartMeasure refDataItem="Orphaned (TB)"/></v2_pieChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top;padding-left:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Storage at Rest %</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(by Business Unit)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_pieChart maxHotspots="10000" name="Pie Chart4" refQuery="Storage at Rest for BU" sliceStartAngle="90">
	<v2_pieTooltips/>
	<style>
		<defaultStyles>
			<defaultStyle refStyle="ch"/>
		</defaultStyles>
		<CSS value="width:300px;height:250px;color:#454545"/></style>
	<noDataHandler>
		<contents>
			<block>
				<contents>
					<textItem>
						<dataSource>
							<staticValue>No Data Available</staticValue>
						</dataSource>
						<style>
							<CSS value="padding:10px 18px;"/>
						</style>
					</textItem>
				</contents>
			</block>
		</contents>
	</noDataHandler>
	<v2_pieSlices borders="show" borderColor="white">
		<v2_solidPalette>
			<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
		<!-- v2_solidPaletteRef ref=&amp;quot;gDefaultSolid&amp;quot;/ -->
		<v2_pieDataLabels pieLabelLeaders="show" pieLabelStyle="radial" pieLabels="show" pieValues="percentage"/><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="BusinessUnit"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_pieSlices>
	<v2_defaultChartMeasure refDataItem="CapacityTB"/></v2_pieChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top;padding-left:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Storage at Rest %</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(by Tier/Service Level)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_pieChart maxHotspots="10000" name="Pie Chart5" refQuery="Storage at Rest - Tier and Vendor" sliceStartAngle="90">
	<v2_pieTooltips/>
	<style>
		<defaultStyles>
			<defaultStyle refStyle="ch"/>
		</defaultStyles>
		<CSS value="width:300px;height:250px;color:#454545"/></style>
	<noDataHandler>
		<contents>
			<block>
				<contents>
					<textItem>
						<dataSource>
							<staticValue>No Data Available</staticValue>
						</dataSource>
						<style>
							<CSS value="padding:10px 18px;"/>
						</style>
					</textItem>
				</contents>
			</block>
		</contents>
	</noDataHandler>
	<v2_pieSlices borders="show" borderColor="white">
		<v2_solidPalette>
			<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
		<!-- v2_solidPaletteRef ref=&amp;quot;gDefaultSolid&amp;quot;/ -->
		<v2_pieDataLabels pieLabelLeaders="show" pieLabelStyle="radial" pieLabels="show" pieValues="percentage"/><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Tier"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_pieSlices>
	<v2_defaultChartMeasure refDataItem="Capacity TB"/></v2_pieChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px;vertical-align:top"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="height:10px;background-color:#F7F7F7;padding-right:10px;padding-left:10px;padding-bottom:10px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents>
								</pageBody>
								
								<pageFooter>
									<contents>
										
									<table>
                                            <tableRows>
                                                <tableRow>
                                                    <tableCells>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <image>
            <dataSource>
                <staticValue>../sanscreen/images/netapp_logo.png</staticValue>
            </dataSource>
        <style><CSS value="width:90px;height:36px"/></style></image></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:left;width:30%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                <textItem><dataSource><staticValue>Page </staticValue></dataSource></textItem><pageNumber/>
                                                            </contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:center;color:#9EA2A2;font-family:Helvetica;font-size:12px;width:40%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <textItem><dataSource><staticValue>OnCommand Insight 7.3.  2014-18 NetApp.</staticValue></dataSource><style><CSS value="font-weight:normal"/></style></textItem></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:right;width:30%;color:#9EA2A2;font-family:Arial;font-size:12px"/>
                                                            </style>
                                                        </tableCell>
                                                    </tableCells>
                                                </tableRow>
                                            </tableRows>
                                            <style>
                                                <defaultStyles>
                                                    <defaultStyle refStyle="tb"/>
                                                </defaultStyles>
                                                <CSS value="border-collapse:collapse;width:100%;height:32px"/>
                                            </style>
                                        </table></contents>
									<style>
										<defaultStyles>
											<defaultStyle refStyle="pf"/>
										</defaultStyles>
										<CSS value="padding-top:10px"/>
									</style>
								</pageFooter>
							</page>
						</reportPages>
					</layout>
				</layouts>
			<XMLAttributes><XMLAttribute name="RS_CreateExtendedDataItems" output="no" value="true"/><XMLAttribute name="listSeparator" output="no" value=","/><XMLAttribute name="RS_modelModificationTime" output="no" value="2017-11-15T20:33:46.905Z"/></XMLAttributes><queries><query name="Config"><source><sqlQuery dataSource="dwh_capacity" name="SQL1" type="passThrough">
			<sqlText>SELECT

orphan.tier as 'Tier',
orphan.cost as 'Cost',
orphan.storage as 'Storage Name',
orphan.vendor as 'Vendor',
orphan.datacenter as 'Data Center',
orphan.storagepool as 'Storage Pool',
orphan.volume as 'Volume',
orphan.orphanedgb as 'Orphaned GB',
estate.businessunit as 'Business Unit'

FROM (


	SELECT 	dwh_capacity.tier_dimension.name AS tier,
		dwh_capacity.tier_dimension.cost as cost,
		dwh_capacity.storage_dimension.name AS storage,
		dwh_capacity.storage_dimension.manufacturer as vendor,
		dwh_capacity.storage_dimension.datacenter as datacenter,
		dwh_capacity.storage_pool_dimension.name AS storagepool,
		dwh_capacity.volume_dimension.name AS volume,
		dwh_capacity.volume_dimension.id AS volumeId,
		'Configuration' AS orphanedby,
		ROUND(dwh_capacity.volume_capacity_fact.orphanedCapacityMB/1024,2) AS orphanedgb,
		dwh_capacity.volume_capacity_fact.isAccessed AS accessed
	FROM 	dwh_capacity.volume_capacity_fact
	JOIN 	dwh_capacity.tier_dimension
	ON 	dwh_capacity.volume_capacity_fact.tierTk = dwh_capacity.tier_dimension.tk
	AND 	dwh_capacity.volume_capacity_fact.isOrphaned = 1
	JOIN 	dwh_capacity.storage_dimension
	ON 	dwh_capacity.volume_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
	JOIN 	dwh_capacity.storage_pool_dimension
	ON 	dwh_capacity.volume_capacity_fact.storagePoolTk = dwh_capacity.storage_pool_dimension.tk
	JOIN 	dwh_capacity.volume_dimension
	ON 	dwh_capacity.volume_capacity_fact.volumeTk = dwh_capacity.volume_dimension.tk
	JOIN	dwh_capacity.chargeback_fact
	ON	dwh_capacity.chargeback_fact.storagetk=dwh_capacity.storage_dimension.tk
	JOIN	dwh_capacity.business_entity_dimension
	ON	dwh_capacity.business_entity_dimension.tk=dwh_capacity.chargeback_fact.businessentitytk
	GROUP BY
		dwh_capacity.volume_dimension.id ) orphan

JOIN

(
select distinct
dwh_capacity.business_entity_dimension.businessunit as businessunit,
dwh_capacity.storage_dimension.name as storage,
dwh_capacity.storage_pool_dimension.name as storagepool

from dwh_capacity.chargeback_fact
JOIN	dwh_capacity.storage_dimension
ON	dwh_capacity.storage_dimension.tk=dwh_capacity.chargeback_fact.storagetk
JOIN	dwh_capacity.storage_pool_dimension
ON	dwh_capacity.storage_pool_dimension.tk=dwh_capacity.chargeback_fact.storagepooltk
JOIN	dwh_capacity.business_entity_dimension
ON	dwh_capacity.business_entity_dimension.tk=dwh_capacity.chargeback_fact.businessentitytk
JOIN	dwh_capacity.date_dimension
ON	dwh_capacity.date_dimension.tk=dwh_capacity.chargeback_fact.datetk
WHERE dwh_capacity.date_dimension.latest=1

) estate ON estate.storage=orphan.storage


</sqlText>
		<mdProjectedItems><mdProjectedItem name="Tier"/><mdProjectedItem name="Cost"/><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Vendor"/><mdProjectedItem name="Data Center"/><mdProjectedItem name="Storage Pool"/><mdProjectedItem name="Volume"/><mdProjectedItem name="Orphaned GB"/><mdProjectedItem name="Business Unit"/></mdProjectedItems></sqlQuery></source><selection><dataItem name="Tier"><expression>[SQL1].[Tier]</expression></dataItem><dataItem name="Cost"><expression>[SQL1].[Cost]</expression></dataItem><dataItem name="Storage Name"><expression>[SQL1].[Storage Name]</expression></dataItem><dataItem name="Vendor"><expression>[SQL1].[Vendor]</expression></dataItem><dataItem name="Data Center"><expression>[SQL1].[Data Center]</expression></dataItem><dataItem name="Storage Pool"><expression>[SQL1].[Storage Pool]</expression></dataItem><dataItem name="Volume"><expression>[SQL1].[Volume]</expression></dataItem><dataItem aggregate="total" name="Orphaned GB"><expression>[SQL1].[Orphaned GB]</expression></dataItem><dataItem name="Business Unit"><expression>[SQL1].[Business Unit]</expression></dataItem></selection><detailFilters><detailFilter><filterExpression>[Business Unit]&lt;&gt;'N/A'</filterExpression></detailFilter></detailFilters></query><query name="Perf"><source><sqlQuery dataSource="dwh_capacity" name="SQL1" type="passThrough">
			<sqlText>		SELECT 	dwh_performance.tier_dimension.name AS 'Tier',
		dwh_performance.tier_dimension.cost as 'Cost',
		dwh_performance.storage_dimension.name AS 'Storage',
		dwh_performance.storage_dimension.manufacturer as 'Vendor',
		dwh_performance.storage_dimension.datacenter as 'Data Center',
		dwh_performance.business_entity_dimension.businessunit as 'Business Unit',
		dwh_performance.storage_pool_dimension.name AS 'Storage Pool',
		dwh_inventory.volume.name AS 'Volume',
		dwh_inventory.volume.id AS volumeId,
		'Performance' AS 'Orphaned by',
		ROUND(dwh_inventory.volume.capacityMB/1024,2) AS 'Orphaned GB',
		MAX(dwh_performance.volume_daily_performance_fact.totalIops) AS accessed
	FROM 	dwh_performance.volume_daily_performance_fact
	JOIN	dwh_performance.business_entity_dimension
	ON	dwh_performance.business_entity_dimension.tk=dwh_performance.volume_daily_performance_fact.businessentitytk
	JOIN 	dwh_performance.date_dimension
	ON 	dwh_performance.volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk
	AND 	dwh_performance.date_dimension.fullDate &gt;= (SELECT MAX(dwh_performance.date_dimension.fullDate) FROM dwh_performance.date_dimension JOIN dwh_performance.volume_daily_performance_fact ON dwh_performance.volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk) - INTERVAL 15 DAY
	JOIN 	dwh_performance.tier_dimension
	ON 	dwh_performance.volume_daily_performance_fact.tierTk = dwh_performance.tier_dimension.tk
	JOIN 	dwh_performance.storage_dimension
	ON 	dwh_performance.volume_daily_performance_fact.storageTk = dwh_performance.storage_dimension.tk
	JOIN 	dwh_performance.storage_pool_dimension
	ON 	dwh_performance.volume_daily_performance_fact.storagePoolTk = dwh_performance.storage_pool_dimension.tk
	JOIN 	dwh_performance.volume_dimension
	ON 	dwh_performance.volume_daily_performance_fact.volumeTk = dwh_performance.volume_dimension.tk
	JOIN 	dwh_inventory.volume
	ON 	dwh_performance.volume_dimension.id = dwh_inventory.volume.id
	JOIN 	dwh_capacity.volume_dimension
	ON 	dwh_capacity.volume_dimension.id = dwh_inventory.volume.id	
	JOIN 	dwh_capacity.volume_capacity_fact 
	ON 	dwh_capacity.volume_capacity_fact.isAccessed = 1
	AND  	dwh_capacity.volume_dimension.tk = dwh_capacity.volume_capacity_fact.volumeTk 
	GROUP BY
		dwh_inventory.volume.id
	HAVING
		accessed = 0</sqlText>
		<mdProjectedItems><mdProjectedItem name="Tier"/><mdProjectedItem name="Cost"/><mdProjectedItem name="Storage"/><mdProjectedItem name="Vendor"/><mdProjectedItem name="Data Center"/><mdProjectedItem name="Business Unit"/><mdProjectedItem name="Storage Pool"/><mdProjectedItem name="Volume"/><mdProjectedItem name="volumeId"/><mdProjectedItem name="Orphaned by"/><mdProjectedItem name="Orphaned GB"/><mdProjectedItem name="accessed"/></mdProjectedItems></sqlQuery></source><selection><dataItem name="Tier"><expression>[SQL1].[Tier]</expression></dataItem><dataItem name="Cost"><expression>[SQL1].[Cost]</expression></dataItem><dataItem name="Storage"><expression>[SQL1].[Storage]</expression></dataItem><dataItem name="Vendor"><expression>[SQL1].[Vendor]</expression></dataItem><dataItem name="Data Center"><expression>[SQL1].[Data Center]</expression></dataItem><dataItem name="Business Unit"><expression>[SQL1].[Business Unit]</expression></dataItem><dataItem name="Storage Pool"><expression>[SQL1].[Storage Pool]</expression></dataItem><dataItem name="Volume"><expression>[SQL1].[Volume]</expression></dataItem><dataItem name="volumeId"><expression>[SQL1].[volumeId]</expression></dataItem><dataItem name="Orphaned by"><expression>[SQL1].[Orphaned by]</expression></dataItem><dataItem aggregate="total" name="Orphaned GB"><expression>[SQL1].[Orphaned GB]</expression></dataItem><dataItem name="accessed"><expression>[SQL1].[accessed]</expression></dataItem></selection><detailFilters><detailFilter><filterExpression>[Orphaned by] contains 'Perf'</filterExpression></detailFilter><detailFilter><filterExpression>[Orphaned GB]&gt;1</filterExpression></detailFilter><detailFilter><filterExpression>[Business Unit]&lt;&gt;'N/A'</filterExpression></detailFilter></detailFilters></query><query name="VM Reclamation Candidates">
			<source>
				
			<sqlQuery dataSource="dwh_inventory" name="SQL2">
			<sqlText>select 
dwh_inventory.hv_virtual_machine.name as 'VM Guest',
count(dwh_inventory.hv_virtual_machine.name) as 'VM Count',
sum(dwh_inventory.hv_virtual_machine.provisionedCapacityMB/1024) as 'Capacity GB'

FROM dwh_inventory.hv_virtual_machine
WHERE dwh_inventory.hv_virtual_machine.powerState='poweredOff'


GROUP BY dwh_inventory.hv_virtual_machine.name</sqlText>
		<mdProjectedItems><mdProjectedItem name="VM Guest"/><mdProjectedItem name="VM Count"/><mdProjectedItem name="Capacity GB"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem aggregate="total" name="VM Count"><expression>[SQL2].[VM Count]</expression></dataItem><dataItem aggregate="total" name="Capacity GB"><expression>[SQL2].[Capacity GB]</expression></dataItem><dataItem name="VM Guest"><expression>[SQL2].[VM Guest]</expression></dataItem></selection>
		</query><query name="Host Map Derived Query">
			<source>
				
			<sqlQuery dataSource="dwh_inventory" name="SQL3">
			<sqlText>select
dwh_repcatalog.host_map.host as 'Host Name',
dwh_repcatalog.host_map_perf.application as 'Application',
dwh_repcatalog.host_map_perf.businessUnit as 'Business Unit',
dwh_repcatalog.host_map.volume as 'Volume',
dwh_repcatalog.host_map.share as 'Share Name',
dwh_repcatalog.host_map.storage as 'Storage Name',
dwh_repcatalog.host_map.vendor as 'Vendor',
dwh_repcatalog.host_map.tier as 'Service Level',
dwh_repcatalog.host_map.tier as 'Tier',
dwh_repcatalog.host_map.protocol as 'Protocol',
dwh_repcatalog.host_map.allocatedGB as 'Allocated GB',
dwh_repcatalog.host_map_perf.totalthroughput as 'Total Throughput (mb/sec)',

if(dwh_repcatalog.host_map_perf.totalthroughput=0,dwh_repcatalog.host_map.allocatedGB, 0) as 'SAR GB',
if(dwh_repcatalog.host_map_perf.totalthroughput=0,dwh_repcatalog.host_map.allocatedGB/1024, 0) as 'SAR TB',

if(dwh_repcatalog.host_map.host is null, dwh_repcatalog.host_map.allocatedGB, 0) as 'Orphaned GB',
if(dwh_repcatalog.host_map.host is null, dwh_repcatalog.host_map.allocatedGB/1024, 0) as 'Orphaned TB',

if(dwh_repcatalog.host_map.protocol in ('CIFS', 'NFS') and dwh_repcatalog.host_map.host is null, 1, 0) as 'Shares without Hosts',
COUNT( dwh_repcatalog.host_map.share ) as 'Share Count',
COUNT(dwh_repcatalog.host_map.volume) as 'Volume Count',
COUNT(dwh_repcatalog.host_map.host) as 'Host Count'

from 	dwh_repcatalog.host_map
JOIN	dwh_repcatalog.host_map_perf
ON	dwh_repcatalog.host_map_perf.volumeid=dwh_repcatalog.host_map.volumeid

GROUP by dwh_repcatalog.host_map.volume</sqlText>
		<mdProjectedItems><mdProjectedItem name="Host Name"/><mdProjectedItem name="Application"/><mdProjectedItem name="Business Unit"/><mdProjectedItem name="Volume"/><mdProjectedItem name="Share Name"/><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Vendor"/><mdProjectedItem name="Service Level"/><mdProjectedItem name="Tier"/><mdProjectedItem name="Protocol"/><mdProjectedItem name="Allocated GB"/><mdProjectedItem name="Total Throughput (mb/sec)"/><mdProjectedItem name="SAR GB"/><mdProjectedItem name="SAR TB"/><mdProjectedItem name="Orphaned GB"/><mdProjectedItem name="Orphaned TB"/><mdProjectedItem name="Shares without Hosts"/><mdProjectedItem name="Share Count"/><mdProjectedItem name="Volume Count"/><mdProjectedItem name="Host Count"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Host Name"><expression>[SQL3].[Host Name]</expression></dataItem><dataItem name="Application"><expression>[SQL3].[Application]</expression></dataItem><dataItem name="Business Unit"><expression>if([SQL3].[Business Unit] is null) then ('Unknown') else ([SQL3].[Business Unit])</expression></dataItem><dataItem name="Volume"><expression>[SQL3].[Volume]</expression></dataItem><dataItem name="Share Name"><expression>[SQL3].[Share Name]</expression></dataItem><dataItem name="Storage Name"><expression>[SQL3].[Storage Name]</expression></dataItem><dataItem name="Vendor"><expression>[SQL3].[Vendor]</expression></dataItem><dataItem name="Service Level"><expression>[SQL3].[Service Level]</expression></dataItem><dataItem name="Tier"><expression>if([SQL3].[Tier] is null) THEN ('Unknown') ELSE ([SQL3].[Tier])</expression></dataItem><dataItem name="Protocol"><expression>[SQL3].[Protocol]</expression></dataItem><dataItem aggregate="total" name="Allocated GB"><expression>[SQL3].[Allocated GB]</expression></dataItem><dataItem aggregate="total" name="Total Throughput (mb/sec)"><expression>[SQL3].[Total Throughput (mb/sec)]</expression></dataItem><dataItem aggregate="total" name="SAR GB"><expression>[SQL3].[SAR GB]</expression></dataItem><dataItem aggregate="total" name="SAR TB"><expression>[SQL3].[SAR TB]</expression></dataItem><dataItem name="% of Total for SAR"><expression>[SAR GB]/[Allocated GB]</expression></dataItem><dataItem aggregate="total" name="Orphaned GB"><expression>[SQL3].[Orphaned GB]</expression></dataItem><dataItem aggregate="total" name="Orphaned TB"><expression>[SQL3].[Orphaned TB]</expression></dataItem><dataItem name="% of Total for Orphaned"><expression>[Orphaned GB]/[Allocated GB]</expression></dataItem><dataItem aggregate="total" name="Shares without Hosts"><expression>[SQL3].[Shares without Hosts]</expression></dataItem><dataItem aggregate="total" name="Share Count"><expression>[SQL3].[Share Count]</expression></dataItem><dataItem name="% of Shares without Host Map"><expression>[Shares without Hosts]/[Share Count]</expression></dataItem><dataItem aggregate="total" name="Volume Count"><expression>[SQL3].[Volume Count]</expression></dataItem><dataItem aggregate="total" name="Host Count"><expression>[SQL3].[Host Count]</expression></dataItem><dataItem name="% of Volumes not Mapped"><expression>[Host Count]/[Volume Count]</expression></dataItem><dataItem aggregate="total" name="Throughput &gt; tenthousand"><expression>if([Total Throughput (mb/sec)]&gt;10000) THEN ([Total Throughput (mb/sec)]) else (0)</expression></dataItem></selection>
		</query><query name="Host Map Derived Query BU Cap">
			<source>
				
			<sqlQuery dataSource="dwh_inventory" name="SQL3">
			<sqlText>select
dwh_repcatalog.host_map.host as 'Host Name',
dwh_repcatalog.host_map_perf.application as 'Application',
dwh_repcatalog.host_map_perf.businessUnit as 'Business Unit',
dwh_repcatalog.host_map.volume as 'Volume',
dwh_repcatalog.host_map.share as 'Share Name',
dwh_repcatalog.host_map.storage as 'Storage Name',
dwh_repcatalog.host_map.vendor as 'Vendor',
dwh_repcatalog.host_map.tier as 'Service Level',
dwh_repcatalog.host_map.tier as 'Tier',
dwh_repcatalog.host_map.protocol as 'Protocol',
dwh_repcatalog.host_map.allocatedGB as 'Allocated GB',
dwh_repcatalog.host_map_perf.totalthroughput as 'Total Throughput (mb/sec)',

if(dwh_repcatalog.host_map_perf.totalthroughput=0,dwh_repcatalog.host_map.allocatedGB, 0) as 'SAR GB',
if(dwh_repcatalog.host_map_perf.totalthroughput=0,dwh_repcatalog.host_map.allocatedGB/1024, 0) as 'SAR TB',

if(dwh_repcatalog.host_map.host is null, dwh_repcatalog.host_map.allocatedGB, 0) as 'Orphaned GB',
if(dwh_repcatalog.host_map.host is null, dwh_repcatalog.host_map.allocatedGB/1024, 0) as 'Orphaned TB',

if(dwh_repcatalog.host_map.protocol in ('CIFS', 'NFS') and dwh_repcatalog.host_map.host is null, 1, 0) as 'Shares without Hosts',
COUNT( dwh_repcatalog.host_map.share ) as 'Share Count',
COUNT(dwh_repcatalog.host_map.volume) as 'Volume Count',
COUNT(dwh_repcatalog.host_map.host) as 'Host Count'

from 	dwh_repcatalog.host_map
JOIN	dwh_repcatalog.host_map_perf
ON	dwh_repcatalog.host_map_perf.volumeid=dwh_repcatalog.host_map.volumeid

GROUP by dwh_repcatalog.host_map.volume</sqlText>
		<mdProjectedItems><mdProjectedItem name="Host Name"/><mdProjectedItem name="Application"/><mdProjectedItem name="Business Unit"/><mdProjectedItem name="Volume"/><mdProjectedItem name="Share Name"/><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Vendor"/><mdProjectedItem name="Service Level"/><mdProjectedItem name="Tier"/><mdProjectedItem name="Protocol"/><mdProjectedItem name="Allocated GB"/><mdProjectedItem name="Total Throughput (mb/sec)"/><mdProjectedItem name="SAR GB"/><mdProjectedItem name="SAR TB"/><mdProjectedItem name="Orphaned GB"/><mdProjectedItem name="Orphaned TB"/><mdProjectedItem name="Shares without Hosts"/><mdProjectedItem name="Share Count"/><mdProjectedItem name="Volume Count"/><mdProjectedItem name="Host Count"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Host Name"><expression>[SQL3].[Host Name]</expression></dataItem><dataItem name="Application"><expression>[SQL3].[Application]</expression></dataItem><dataItem name="Business Unit"><expression>if([SQL3].[Business Unit] is null) then ('Unknown') else ([SQL3].[Business Unit])</expression></dataItem><dataItem name="Volume"><expression>[SQL3].[Volume]</expression></dataItem><dataItem name="Share Name"><expression>[SQL3].[Share Name]</expression></dataItem><dataItem name="Storage Name"><expression>[SQL3].[Storage Name]</expression></dataItem><dataItem name="Vendor"><expression>[SQL3].[Vendor]</expression></dataItem><dataItem name="Service Level"><expression>[SQL3].[Service Level]</expression></dataItem><dataItem name="Tier"><expression>if([SQL3].[Tier] is null) THEN ('Unknown') ELSE ([SQL3].[Tier])</expression></dataItem><dataItem name="Protocol"><expression>[SQL3].[Protocol]</expression></dataItem><dataItem aggregate="total" name="Allocated GB"><expression>[SQL3].[Allocated GB]</expression></dataItem><dataItem aggregate="total" name="Total Throughput (mb/sec)"><expression>[SQL3].[Total Throughput (mb/sec)]</expression></dataItem><dataItem aggregate="total" name="SAR GB"><expression>[SQL3].[SAR GB]</expression></dataItem><dataItem aggregate="total" name="SAR TB"><expression>[SQL3].[SAR TB]</expression></dataItem><dataItem name="% of Total for SAR"><expression>[SAR GB]/[Allocated GB]</expression></dataItem><dataItem aggregate="total" name="Orphaned GB"><expression>[SQL3].[Orphaned GB]</expression></dataItem><dataItem name="% of Total for Orphaned"><expression>[Orphaned GB]/[Allocated GB]</expression></dataItem><dataItem aggregate="total" name="Shares without Hosts"><expression>[SQL3].[Shares without Hosts]</expression></dataItem><dataItem aggregate="total" name="Share Count"><expression>[SQL3].[Share Count]</expression></dataItem><dataItem name="% of Shares without Host Map"><expression>[Shares without Hosts]/[Share Count]</expression></dataItem><dataItem aggregate="total" name="Volume Count"><expression>[SQL3].[Volume Count]</expression></dataItem><dataItem aggregate="total" name="Host Count"><expression>[SQL3].[Host Count]</expression></dataItem><dataItem name="% of Volumes not Mapped"><expression>[Host Count]/[Volume Count]</expression></dataItem><dataItem aggregate="total" name="Throughput &gt; tenthousand"><expression>if([Total Throughput (mb/sec)]&gt;10000) THEN ([Total Throughput (mb/sec)]) else (0)</expression></dataItem></selection>
		<detailFilters><detailFilter><filterExpression>[Orphaned GB]&gt;0</filterExpression></detailFilter></detailFilters></query><query name="Host Map Derived Query BU Perf">
			<source>
				
			<sqlQuery dataSource="dwh_inventory" name="SQL3">
			<sqlText>select
dwh_repcatalog.host_map.host as 'Host Name',
dwh_repcatalog.host_map_perf.application as 'Application',
dwh_repcatalog.host_map_perf.businessUnit as 'Business Unit',
dwh_repcatalog.host_map.volume as 'Volume',
dwh_repcatalog.host_map.share as 'Share Name',
dwh_repcatalog.host_map.storage as 'Storage Name',
dwh_repcatalog.host_map.vendor as 'Vendor',
dwh_repcatalog.host_map.tier as 'Service Level',
dwh_repcatalog.host_map.tier as 'Tier',
dwh_repcatalog.host_map.protocol as 'Protocol',
dwh_repcatalog.host_map.allocatedGB as 'Allocated GB',
dwh_repcatalog.host_map_perf.totalthroughput as 'Total Throughput (mb/sec)',

if(dwh_repcatalog.host_map_perf.totalthroughput=0,dwh_repcatalog.host_map.allocatedGB, 0) as 'SAR GB',
if(dwh_repcatalog.host_map_perf.totalthroughput=0,dwh_repcatalog.host_map.allocatedGB/1024, 0) as 'SAR TB',

if(dwh_repcatalog.host_map.host is null, dwh_repcatalog.host_map.allocatedGB, 0) as 'Orphaned GB',
if(dwh_repcatalog.host_map.host is null, dwh_repcatalog.host_map.allocatedGB/1024, 0) as 'Orphaned TB',

if(dwh_repcatalog.host_map.protocol in ('CIFS', 'NFS') and dwh_repcatalog.host_map.host is null, 1, 0) as 'Shares without Hosts',
COUNT( dwh_repcatalog.host_map.share ) as 'Share Count',
COUNT(dwh_repcatalog.host_map.volume) as 'Volume Count',
COUNT(dwh_repcatalog.host_map.host) as 'Host Count'

from 	dwh_repcatalog.host_map
JOIN	dwh_repcatalog.host_map_perf
ON	dwh_repcatalog.host_map_perf.volumeid=dwh_repcatalog.host_map.volumeid

GROUP by dwh_repcatalog.host_map.volume</sqlText>
		<mdProjectedItems><mdProjectedItem name="Host Name"/><mdProjectedItem name="Application"/><mdProjectedItem name="Business Unit"/><mdProjectedItem name="Volume"/><mdProjectedItem name="Share Name"/><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Vendor"/><mdProjectedItem name="Service Level"/><mdProjectedItem name="Tier"/><mdProjectedItem name="Protocol"/><mdProjectedItem name="Allocated GB"/><mdProjectedItem name="Total Throughput (mb/sec)"/><mdProjectedItem name="SAR GB"/><mdProjectedItem name="SAR TB"/><mdProjectedItem name="Orphaned GB"/><mdProjectedItem name="Orphaned TB"/><mdProjectedItem name="Shares without Hosts"/><mdProjectedItem name="Share Count"/><mdProjectedItem name="Volume Count"/><mdProjectedItem name="Host Count"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Host Name"><expression>[SQL3].[Host Name]</expression></dataItem><dataItem name="Application"><expression>[SQL3].[Application]</expression></dataItem><dataItem name="Business Unit"><expression>[SQL3].[Business Unit]</expression></dataItem><dataItem name="Volume"><expression>[SQL3].[Volume]</expression></dataItem><dataItem name="Share Name"><expression>[SQL3].[Share Name]</expression></dataItem><dataItem name="Storage Name"><expression>[SQL3].[Storage Name]</expression></dataItem><dataItem name="Vendor"><expression>[SQL3].[Vendor]</expression></dataItem><dataItem name="Service Level"><expression>[SQL3].[Service Level]</expression></dataItem><dataItem name="Tier"><expression>[SQL3].[Tier]</expression></dataItem><dataItem name="Protocol"><expression>[SQL3].[Protocol]</expression></dataItem><dataItem aggregate="total" name="Allocated GB"><expression>[SQL3].[Allocated GB]</expression></dataItem><dataItem aggregate="total" name="Total Throughput (mb/sec)"><expression>[SQL3].[Total Throughput (mb/sec)]</expression></dataItem><dataItem aggregate="total" name="SAR GB"><expression>[SQL3].[SAR GB]</expression></dataItem><dataItem aggregate="total" name="SAR TB"><expression>[SQL3].[SAR TB]</expression></dataItem><dataItem name="% of Total for SAR"><expression>[SAR GB]/[Allocated GB]</expression></dataItem><dataItem aggregate="total" name="Orphaned GB"><expression>[SQL3].[Orphaned GB]</expression></dataItem><dataItem aggregate="total" name="Orphaned TB"><expression>[SQL3].[Orphaned TB]</expression></dataItem><dataItem name="% of Total for Orphaned"><expression>[Orphaned GB]/[Allocated GB]</expression></dataItem><dataItem aggregate="total" name="Shares without Hosts"><expression>[SQL3].[Shares without Hosts]</expression></dataItem><dataItem aggregate="total" name="Share Count"><expression>[SQL3].[Share Count]</expression></dataItem><dataItem name="% of Shares without Host Map"><expression>[Shares without Hosts]/[Share Count]</expression></dataItem><dataItem aggregate="total" name="Volume Count"><expression>[SQL3].[Volume Count]</expression></dataItem><dataItem aggregate="total" name="Host Count"><expression>[SQL3].[Host Count]</expression></dataItem><dataItem name="% of Volumes not Mapped"><expression>[Host Count]/[Volume Count]</expression></dataItem><dataItem aggregate="total" name="Throughput &gt; tenthousand"><expression>if([Total Throughput (mb/sec)]&gt;10000) THEN ([Total Throughput (mb/sec)]) else (0)</expression></dataItem></selection>
		</query><query name="Orphaned by Vendor">
			<source>
				
			<sqlQuery name="SQL4" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT
dwh_capacity.storage_dimension.manufacturer as 'Manufacturer',
ROUND(SUM(dwh_capacity.volume_history_capacity_fact.orphanedCapacityMB)/1024/1024,2) as 'Orphaned (TB)'


FROM dwh_capacity.volume_history_capacity_fact
JOIN dwh_capacity.storage_dimension
ON dwh_capacity.storage_dimension.tk=dwh_capacity.volume_history_capacity_fact.storagetk
JOIN dwh_capacity.date_dimension
ON dwh_capacity.date_dimension.tk=dwh_capacity.volume_history_capacity_fact.datetk 
WHERE dwh_capacity.volume_history_capacity_fact.orphanedCapacityMB is not null

GROUP BY dwh_capacity.storage_dimension.manufacturer




</sqlText>
		<mdProjectedItems><mdProjectedItem name="Manufacturer"/><mdProjectedItem name="Orphaned (TB)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Manufacturer"><expression>[SQL4].[Manufacturer]</expression></dataItem><dataItem name="Orphaned (TB)" aggregate="total"><expression>[SQL4].[Orphaned (TB)]</expression></dataItem></selection>
		</query><query name="Orphaned by BU">
			<source>
				
			<sqlQuery name="SQL5" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT
IF(dwh_capacity.business_entity_dimension.businessunit='N/A', 'Not Assigned', SUBSTRING(dwh_capacity.business_entity_dimension.businessunit,1,10)) as 'Business Unit',
ROUND(SUM(dwh_capacity.volume_history_capacity_fact.orphanedCapacityMB)/1024/1024,2) as 'Orphaned (TB)'

FROM dwh_capacity.volume_history_capacity_fact
JOIN dwh_capacity.date_dimension
ON dwh_capacity.date_dimension.tk=dwh_capacity.volume_history_capacity_fact.datetk
LEFT JOIN dwh_capacity.chargeback_fact
ON dwh_capacity.chargeback_fact.tk=dwh_capacity.volume_history_capacity_fact.chargebackfacttk
LEFT JOIN dwh_capacity.business_entity_dimension
ON dwh_capacity.business_entity_dimension.tk=dwh_capacity.chargeback_fact.businessentitytk

GROUP BY dwh_capacity.business_entity_dimension.businessunit</sqlText>
		<mdProjectedItems><mdProjectedItem name="Business Unit"/><mdProjectedItem name="Orphaned (TB)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Business Unit"><expression>[SQL5].[Business Unit]</expression></dataItem><dataItem name="Orphaned (TB)" aggregate="total"><expression>[SQL5].[Orphaned (TB)]</expression></dataItem></selection>
		<detailFilters><detailFilter><filterExpression>[Business Unit] is not null</filterExpression></detailFilter><detailFilter><filterExpression>[Orphaned (TB)] is not null</filterExpression></detailFilter></detailFilters></query><query name="Orphaned by Service Level or Tier">
			<source>
				
			<sqlQuery name="SQL6" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT
IF(dwh_capacity.tier_dimension.name='N/A', 'Not Assigned', dwh_capacity.tier_dimension.name) as 'Service Level',
ROUND(SUM(dwh_capacity.volume_history_capacity_fact.orphanedCapacityMB)/1024/1024,2) as 'Orphaned (TB)'

FROM dwh_capacity.volume_history_capacity_fact
JOIN dwh_capacity.date_dimension
ON dwh_capacity.date_dimension.tk=dwh_capacity.volume_history_capacity_fact.datetk
AND dwh_capacity.date_dimension.latest=1
LEFT JOIN dwh_capacity.tier_dimension
ON dwh_capacity.tier_dimension.tk=dwh_capacity.volume_history_capacity_fact.tiertk


GROUP BY dwh_capacity.tier_dimension.tk</sqlText>
		<mdProjectedItems><mdProjectedItem name="Service Level"/><mdProjectedItem name="Orphaned (TB)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Service Level"><expression>[SQL6].[Service Level]</expression></dataItem><dataItem name="Orphaned (TB)" aggregate="total"><expression>[SQL6].[Orphaned (TB)]</expression></dataItem></selection>
		<detailFilters><detailFilter><filterExpression>[Service Level] not contains 'Pure'</filterExpression></detailFilter></detailFilters></query><query name="Storage at Rest - Tier and Vendor">
			<source>
				
			<sqlQuery name="SQL7" dataSource="dwh_performance" type="passThrough">
			<sqlText>SELECT
cap.StorageName as 'Storage Name',
cap.Vendor as 'Vendor',
cap.Volume as 'Volume',
perf.totaliops as 'Total IOpS',
cap.CapacityTB as 'Capacity TB',
cap.Tier as 'Tier'

FROM 
(
SELECT
dwh_inventory.storage.name as 'StorageName',
dwh_inventory.storage.manufacturer as 'Vendor',
CONCAT(dwh_inventory.storage.name,' - ',dwh_inventory.volume.name) as 'Volume',
ROUND(dwh_inventory.volume.capacityMB/1024/1024,0) as 'CapacityTB',
IF(dwh_inventory.annotation_value.annotationType='Tier', dwh_inventory.annotation_value.valueIdentifier, null) as 'Tier',

dwh_inventory.volume.id as volid
FROM dwh_inventory.volume
JOIN dwh_inventory.storage
On dwh_inventory.storage.id=dwh_inventory.volume.storageid
LEFT JOIN dwh_inventory.object_to_annotation
ON dwh_inventory.object_to_annotation.objectid=dwh_inventory.volume.id
LEFT JOIN dwh_inventory.annotation_value
ON dwh_inventory.annotation_value.id=dwh_inventory.object_to_annotation.annotationValueId

GROUP BY dwh_inventory.storage.id,dwh_inventory.volume.id

UNION

SELECT
dwh_inventory.storage.name as 'StorageName',
dwh_inventory.storage.manufacturer as 'Vendor',
CONCAT(dwh_inventory.storage.name,' - ',dwh_inventory.internal_volume.name) as 'Volume',
ROUND(dwh_inventory.internal_volume.totalAllocatedcapacityMB/1024/1024,0) as 'CapacityTB',
IF(dwh_inventory.annotation_value.annotationType='Tier', dwh_inventory.annotation_value.valueIdentifier, null) as 'Tier',
dwh_inventory.internal_volume.id as volid
FROM dwh_inventory.internal_volume
JOIN dwh_inventory.storage
On dwh_inventory.storage.id=dwh_inventory.internal_volume.storageid
LEFT JOIN dwh_inventory.object_to_annotation
ON dwh_inventory.object_to_annotation.objectid=dwh_inventory.internal_volume.id
LEFT JOIN dwh_inventory.annotation_value
ON dwh_inventory.annotation_value.id=dwh_inventory.object_to_annotation.annotationValueId


WHERE dwh_inventory.internal_volume.type&lt;&gt;'filesystem'
GROUP BY dwh_inventory.storage.id, dwh_inventory.internal_volume.id



) cap

JOIN

(
SELECT 
dwh_custom.vol_perf_daily.volid,
SUM(dwh_custom.vol_perf_daily.totaliops)  AS totaliops

FROM dwh_custom.vol_perf_daily
WHERE dwh_custom.vol_perf_daily.fullDate &gt;= (SELECT MAX(dwh_custom.vol_perf_daily.fullDate) 
FROM dwh_custom.vol_perf_daily) - INTERVAL 91 DAY

GROUP BY dwh_custom.vol_perf_daily.volid ) perf ON perf.volid=cap.volid
AND perf.totaliops = 0





</sqlText>
		<mdProjectedItems><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Vendor"/><mdProjectedItem name="Volume"/><mdProjectedItem name="Total IOpS"/><mdProjectedItem name="Capacity TB"/><mdProjectedItem name="Tier"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Storage Name"><expression>[SQL7].[Storage Name]</expression></dataItem><dataItem name="Vendor"><expression>[SQL7].[Vendor]</expression></dataItem><dataItem name="Volume"><expression>[SQL7].[Volume]</expression></dataItem><dataItem name="Total IOpS"><expression>[SQL7].[Total IOpS]</expression></dataItem><dataItem name="Capacity TB" aggregate="total"><expression>[SQL7].[Capacity TB]</expression></dataItem><dataItem name="Tier"><expression>[SQL7].[Tier]</expression></dataItem></selection>
		</query><query name="Storage at Rest for BU">
			<source>
				
			<sqlQuery name="SQL8" dataSource="dwh_performance" type="passThrough">
			<sqlText>SELECT
CB.BusinessUnit as BusinessUnit,
CB.CapacityTB as CapacityTB,
perf.totaliops as totaliops


FROM (

SELECT
0 as ivolid,
dwh_capacity.business_entity_dimension.businessunit as 'BusinessUnit',
ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024/1024,2) as 'CapacityTB'

FROM dwh_capacity.chargeback_fact
JOIN dwh_capacity.business_entity_dimension
ON dwh_capacity.business_entity_dimension.tk=dwh_capacity.chargeback_fact.businessentitytk
JOIN dwh_capacity.date_dimension
ON dwh_capacity.date_dimension.tk=dwh_capacity.chargeback_fact.datetk
AND dwh_capacity.date_dimension.latest=1


GROUP BY dwh_capacity.business_entity_dimension.businessunit ) CB

JOIN 
(
SELECT
dwh_custom.pool_perf_fact.businessUnit as businessUnit,
SUM(dwh_custom.pool_perf_fact.avgIOpS)  AS totaliops

FROM dwh_custom.pool_perf_fact
WHERE dwh_custom.pool_perf_fact.fullDate &gt;= (SELECT MAX(dwh_custom.pool_perf_fact.fullDate) 
FROM dwh_custom.pool_perf_fact) - INTERVAL 91 DAY

GROUP BY dwh_custom.pool_perf_fact.businessUnit ) perf ON perf.businessUnit=CB.BusinessUnit
AND perf.totaliops = 0

UNION

SELECT
ivcap.BusinessUnit as BusinessUnit,
ivcap.CapacityTB as CapacityTB,
perf.totaliops as totaliops

FROM
(

SELECT
dwh_capacity.internal_volume_dimension.id as ivolid,
dwh_capacity.business_entity_dimension.businessunit as 'BusinessUnit',
dwh_capacity.internal_volume_capacity_fact.allocatedCapacityMB/1024/1024 as 'CapacityTB'

FROM dwh_capacity.internal_volume_capacity_fact
JOIN dwh_capacity.internal_volume_dimension
ON dwh_capacity.internal_volume_dimension.tk=dwh_capacity.internal_volume_capacity_fact.internalvolumetk
JOIN dwh_capacity.business_entity_dimension
ON dwh_capacity.business_entity_dimension.tk=dwh_capacity.internal_volume_capacity_fact.businessentitytk
JOIN dwh_capacity.date_dimension
ON dwh_capacity.date_dimension.tk=dwh_capacity.internal_volume_capacity_fact.datetk
AND dwh_capacity.date_dimension.latest=1

GROUP BY dwh_capacity.internal_volume_dimension.id ) ivcap

JOIN

(
SELECT 
dwh_custom.vol_perf_daily.volid,
SUM(dwh_custom.vol_perf_daily.totaliops)  AS totaliops

FROM dwh_custom.vol_perf_daily
WHERE dwh_custom.vol_perf_daily.fullDate &gt;= (SELECT MAX(dwh_custom.vol_perf_daily.fullDate) 
FROM dwh_custom.vol_perf_daily) - INTERVAL 91 DAY

GROUP BY dwh_custom.vol_perf_daily.volid ) perf ON perf.volid=ivcap.ivolid
AND perf.totaliops = 0









</sqlText>
		<mdProjectedItems><mdProjectedItem name="BusinessUnit"/><mdProjectedItem name="CapacityTB"/><mdProjectedItem name="totaliops"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="BusinessUnit"><expression>IF([SQL8].[BusinessUnit]='N/A') THEN ('Not Assigned') ELSE ([SQL8].[BusinessUnit])</expression></dataItem><dataItem name="CapacityTB" aggregate="total"><expression>[SQL8].[CapacityTB]</expression></dataItem><dataItem name="totaliops"><expression>[SQL8].[totaliops]</expression></dataItem></selection>
		</query></queries><reportName>2.16 Capacity Recovery or Cost Reduction - Executive</reportName></report>